Collapse All Expand All

The Recovery Account Transactions and Repayment Plan Transactions screens provide recovery agents with the ability to view the transactions that have occurred on a recovery account or repayment plan. Additionally, both screens contain a Reverse Transaction button that allows for non-interest transactions to be reversed, as well as an Export button that allows for historical transaction data to be easily exported and viewed within Excel.

For more information on how transactions are created, please see the Recovery Transactions topic within the User Guide.

 

Within this topic, the following Recovery Account and Repayment Plan Transaction screen details and actions are defined:

• Account Selection
• Viewing Transactions
  • Active Transactions
  • Transaction Allocations
  • Active Transactions – All Interest
  • All Transactions
  • Active Ledger
  • All Ledger Entries
• Reversing Transactions
• Exporting Transactions

Account Selection

The Recovery Account Transactions and Repayment Plan Transactions screens allow the user to view account transactions for all accounts held by the person in context. Users can toggle between accounts by clicking on the drop-down menu at the top of the screen.

 

Filtering Transactions By Date

By default, the Recovery Account Transactions and Repayment Plan Transactions screens display all transactions within three months prior to today's date, based on the transaction's Effective Date. However, users are able to refine the results displayed in the grid by modifying the date range.

The date range can be modified by using one of the following methods:

• Click the or  buttons to change the date range in three-month increments.
• Click within the To and From fields to open a calendar tool, which enables the user to select the desired dates. A user may also manually enter dates into the To and From text boxes.

After the date range is selected, click  to update the grid to display the transaction history.

Viewing Transactions

Within the Recovery Account Transactions and Repayment Plan Transactions screens, transactions populate within the transactions grid. By default, transactions are sorted by Effective Date, with the newest dated transaction appearing first. Each transaction is listed as a row within the grid, with columns designating various fields of information based on the view selected.

Within these screens, there are six views available to recovery agents:

• Active Transactions
• Active Transactions - All Interest
• All Transactions
• Transaction Allocations
• Active Ledger Entries
• All Ledger Entries

To choose which view displays within the workspace, click within the views drop-down and select the desired view.

Upon selecting a view, the transactions grid refreshes to display the applicable transactions in rows and details in columns.

Active Transactions View

The Active Transactions View is used to view the high-level details of the transaction, and displays by default. This shows only transactions that are neither reversed nor a reversal transaction. In this view, interest is netted.

Details of each transaction are itemized within a grid containing the following columns:

Column Name	Description
Transaction Id	Displays the Id number by which the Transaction is identified.
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Amount	Displays the amount of the transaction.
Reference Number	Displays a check number, Visa card number or any other number related to the transaction.
Reference Date	Displays a reference date.
Description	Displays any additional information regarding the transaction.
Received From	Displays the name of the person from whom payment is received.
Reverses Transaction Id	Displays Reverses Transaction Id.
Remaining Balance	Displays the total remaining balance for the GL account after a transaction is processed.
Created Date	Displays the date the transaction was added.
Created By	Displays the name of the user who created the transaction.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

Active Ledger Entries View

The Active Ledger Entries View is used to view the ledger entries generated by a transaction, including the accounts and amounts that were affected by the transactions. All interest transactions are shown individually for each day, and interest transactions are not netted.

Details of each transaction are itemized within a grid containing the following columns:

Column Name	Description
Transaction Id	Displays the Id number by which the Transaction is identified.
Ledger Entry Id	Displays the Id number by which the Ledger Entry is identified.
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Transaction Amount	Displays the amount of the transaction.
GL Forward Account Name	Displays the name of the specific GL Forward Account being credited.
GL Forward FQAN	Displays the fully qualified account number of the account being credited.
GL Offset Account Name	Displays the name of the specific Offset Account being debited.
GL Offset FQAN	Displays the fully qualified account number of the account being debited.
Amount	Displays the specific amount being credited to the account.
Remaining Balance	Displays the total remaining balance for the GL account after a transaction is processed.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

Active Transactions - All Interest View

The Active Transactions - All Interest View shows only transactions that are not reversed or are not in a reversal transaction. In this view, all interest transactions are shown individually for each day and interest transactions are not netted.

Details of each transaction are itemized within a grid containing the following columns:

Column Name	Description
Transaction Id	Displays the Id number by which the Transaction is identified.
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Amount	Displays the amount of the transaction.
Reference Number	Displays a check number, Visa card number or any other number related to the transaction.
Reference Date	Displays a reference date.
Description	Displays any additional information regarding the transaction.
Received From	Displays the name of the person from whom payment is received.
Reverses Transaction Id	Displays Reverses Transaction Id.
Remaining Balance	Displays the total remaining balance for the GL account after a transaction is processed.
Created Date	Displays the date the transaction was added.
Created By	Displays the name of the user who created the transaction.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

All Transactions View

The All Transactions View shows all transactions, including those that are reversed or are reversal transactions. In this view, all interest transactions are shown individually for each day and interest transactions are not netted. Backdated transactions show an interest reversal and a new interest posting (after the payment-reduced principal balance) for each date from the day after the payment until the current date.

Details of each transaction within this view are itemized within a grid containing the following columns:

Column Name	Description
Transaction Id	Displays the Id number by which the Transaction is identified.
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Amount	Displays the amount of the transaction using four decimal places.
Reference Number	Displays a check number, Visa card number or any other number related to the transaction.
Reference Date	Displays a reference date.
Description	Displays any additional information regarding the transaction.
Received From	Displays the name of the person from whom payment is received.
Reverses Transaction Id	Displays Reverses Transaction Id.
Remaining Balance	Displays the total remaining balance for the GL account after a transaction is processed using four decimal places.
Created Date	Displays the date the transaction was added.
Created By	Displays the name of the user who created the transaction.
Reversal Reason	Displays the reversal reason given, if the Recovery module is configured within System Management to require reversal reasons.
Reversal Comment	Displays the reversal comment given, if the Recovery module is configured within System Management to require reversal comments.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

Transaction Allocations View

The Transaction Allocations View shows the transactions for a Recovery Account or Repayment Plan in addition to their roll up to the GL Component Type. The view will display the following transactions:

• An Interest Accrual transaction with the date of the final day of the previous month showing the netted interest from that month. This row will also show the GL account that is affected by this transaction as well as the amount that is applied to that account and the balance of the GL account.
• An Interest Accrual transaction with today's date showing the netted interest from the first day of the month up until today. This row will also show the GL account that is affected by this transaction as well as the amount that is applied to that account and the balance of the GL account.
• The Payment Transaction posted as well as the GL account(s) affected by the payment and the balance of the GL account(s).

Details of each transaction within this view are itemized within a grid containing the following columns:

Column Name	Description
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Amount	Displays the amount of the transaction.
Principal	Displays the sum of all entries that have an ancestor with a component type of Principal for this transaction.
Interest	Displays the sum of all entries that have an ancestor with a component type of Interest for this transaction.
R. Expenses	Displays the sum of all entries that have an ancestor with a component type of Reimbursable Expenses for this transaction.
R. Other	Displays the sum of all entries that have an ancestor with a component type of Reimbursable Other for this transaction.
N. Expenses	Displays the sum of all entries that have an ancestor with a component type of Non-Reimbursable Expenses for this transaction.
N. Other	Displays the sum of all entries that have an ancestor with a component type of Non-Reimbursable Other for this transaction.
P Bal	Displays the sum of all entries that have an ancestor with a component type of Principal.
I Bal	Displays the sum of all entries that have an ancestor with a component type of Interest.
RE Bal	Displays the sum of all entries that have an ancestor with a component type of Reimbursable Expenses.
RO Bal	Displays the sum of all entries that have an ancestor with a component type of Reimbursable Other.
NE Bal	Displays the sum of all entries that have an ancestor with a component type of Non-Reimbursable Expenses.
NO Bal	Displays the sum of all entries that have an ancestor with a component type of Non-Reimbursable Other.
Remaining Balance	Displays the remaining balance.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

All Ledger Entries View

The All Ledger Entries view shows all ledger entries. In this view, all interest transactions are shown individually for each day and interest transactions are not netted.

Details of each transaction are itemized within a grid containing the following columns:

Column Name	Description
Transaction Id	Displays the Id number by which the Transaction is identified.
Ledger Entry Id	Displays the Id number by which the Ledger Entry is identified.
Posting Date	Displays the date the transaction is applied.
Effective Date	Displays the date the transaction is in effect.
Transaction Code	Displays the code used to determine the General Ledger (GL) accounts to which the transaction applies. The transaction code also determines account allocations.
Transaction Amount	Displays the amount of the transaction.
GL Forward Account Name	Displays the name of the specific GL Forward Account being credited.
GL Forward FQAN	Displays the fully qualified account number of the account being credited.
GL Offset Account Name	Displays the name of the specific Offset Account being debited.
GL Offset FQAN	Displays the fully qualified account number of the account being debited.
Amount	Displays the specific amount being credited to the account.
Remaining Balance	Displays the total remaining balance for the GL account after a transaction is processed.
Is Transferred	If selected, indicates that the transaction is an expense that has transferred to a Recovery GL Account successfully. This check box is read-only. For more information on transferring expenses, please see the Transfer Expenses Workflow Step topic in the User Guide.

Reversing Transactions

The Reverse Transaction button allows for non-interest transactions to be reversed.

When viewing transactions, the  button is initially disabled. To enable the button, highlight the desired transaction.

If the Recovery module is configured within System Management > Modules > Recovery to require reversal reasons, a Reversal Reason and Comment box will open when the  button is clicked.

 

Choose a Reversal Reason from the drop-down and enter comments as necessary.

When finished, click . A final Reverse Transaction Confirmation window appears. Click OK to confirm. A message appears stating that the reversal was successful.

 

Exporting Transactions

The Export button downloads a .CSV file containing an itemized list of all transactions based on the current selected View that can be exported into Excel.

To export the current selected view, click . A message appears asking to open or save the .CSV file. Choosing Open opens the file in Excel. Choosing Save downloads the file automatically. 

 

 

---

©2020 Temenos Headquarters SA - all rights reserved.

Send Feedback